UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hqT2MgwjuLtuQFuU6VEPoQpthOHb12yEAf+P+EsicbY='
WHERE
key_id = '5b645fea6e380c0ad90d579422625eb1e3c81b17844eed6781e3e0103a4d592c'
AND (
token = 'hqT2MgwjuLtuQFuU6VEPoQpthOHb12yEAf+P+EsicbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)