UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qQP1jkGPxVfANj9pFRq7KN5jKuM1hyOmn2d4E22Z+Fs='
WHERE
key_id = 'a1e4b16c9b2372b501990fb1a318f470b5c097bf64c01cc890eaac3bad7a70d8'
AND (
token = 'qQP1jkGPxVfANj9pFRq7KN5jKuM1hyOmn2d4E22Z+Fs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)