UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrL07EQJ2u02PKwZlo2rErh7+8hYq/2E7Ddd9OtcmgU='
WHERE
key_id = 'ac61b1cf3314270073948f1ff6c2a6135d71c44dc5f58dc6d0d2fac5cca807a4'
AND (
token = 'qrL07EQJ2u02PKwZlo2rErh7+8hYq/2E7Ddd9OtcmgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)