UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FiH9W7XOo1qlHsrSguJpdU3wnflc3m5opVll9Zm3DWI='
WHERE
key_id = 'e69ff430ea13346d67d6c64803d6af9097efb56dc517828a18c3e03d9c5eade5'
AND (
token = 'FiH9W7XOo1qlHsrSguJpdU3wnflc3m5opVll9Zm3DWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)