UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EG59doRmpXuauqMWk9x1HIH9Z8AsGn2+dSwGYLsBplE='
WHERE
key_id = 'd7506985bb5a699c3c87877824c1257dbe9301fbe29cf42c25b87898f7d26691'
AND (
token = 'EG59doRmpXuauqMWk9x1HIH9Z8AsGn2+dSwGYLsBplE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)