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