UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HgjH9BxdIMOPj8EVTLPmpWZN7nwlvIp0i+SJVWxap+8='
WHERE
key_id = 'ef2898230f20d495789d3a9862a5b37c06e9119726822994ac1072e7a5897dff'
AND (
token = 'HgjH9BxdIMOPj8EVTLPmpWZN7nwlvIp0i+SJVWxap+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)