UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTul9giWq8VPYKj2KMRuZM51F4ZSAeWSQDjezz9n0Pc='
WHERE
key_id = '9ad9b2b576eaf08538d4807b4174075946e78aad42d90d841ae166f08df8d9b2'
AND (
token = 'HTul9giWq8VPYKj2KMRuZM51F4ZSAeWSQDjezz9n0Pc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)