UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUYVis48oN8gMg1lrngoB9Zrp2jJulh90CDL4JEa6DI='
WHERE
key_id = 'cc0232e670d9e9eeb46dc05d36522e7650ea7934c77846ca37a48e25ecd77f49'
AND (
token = 'hUYVis48oN8gMg1lrngoB9Zrp2jJulh90CDL4JEa6DI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)