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