UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZfaNizThRlfKdilT1gIaPipx6VykMo06uPN2IIj0Wk='
WHERE
key_id = '7e2d3ee95ab019dab7c9a3ff6da586637a4173764386215ea51a211a025505ac'
AND (
token = 'XZfaNizThRlfKdilT1gIaPipx6VykMo06uPN2IIj0Wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)