UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bG9BsA2iKEWeEKSRwScvv2JiXiD08ZR9nNsxGr8Ws+o='
WHERE
key_id = 'f6e42b7d6f144030b01d4672d9a4b2b80513d12facb3cbc1a1ebf79769f8528e'
AND (
token = 'bG9BsA2iKEWeEKSRwScvv2JiXiD08ZR9nNsxGr8Ws+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)