UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iJM6bIFs/VJ30rRP1e4fhoccY8mw60CYtHS2QRe+Vg='
WHERE
key_id = '897778f7ea3b471a56fea9df235e368531c5fa72bb44713b4bc22eb9abf2d8e7'
AND (
token = '6iJM6bIFs/VJ30rRP1e4fhoccY8mw60CYtHS2QRe+Vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)