UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dJXhl5OwPIJc2Xfic/CZ2IvkN4SLiOTFIF3KS20j4Ew='
WHERE
key_id = 'b11ad7bfd2dfbe710c6b3d74ba1f48c3dc6fd3448eaa53090f11178447be1765'
AND (
token = 'dJXhl5OwPIJc2Xfic/CZ2IvkN4SLiOTFIF3KS20j4Ew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)