UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MI1qstqNfhTqwPpC2JjYC9PjLAv7ENHmeZBo2Fp40HI='
WHERE
key_id = '66164b7e3152da983b3867b872a54f662b5d4eb5373d3e2dba414339ec54739a'
AND (
token = 'MI1qstqNfhTqwPpC2JjYC9PjLAv7ENHmeZBo2Fp40HI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)