UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZaN0G0d6Jf4GHmk+tgMWbl7TOVkv0FaeFchxhGMNpto='
WHERE
key_id = '1a474022139fc7b4b451414c176e8a1feef6ff30aa64d1d3742829fe95b78a0a'
AND (
token = 'ZaN0G0d6Jf4GHmk+tgMWbl7TOVkv0FaeFchxhGMNpto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)