UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gH2ugqYfoF22vQ8xbkov5IjOF8F67Zcy3QXbLes6sY='
WHERE
key_id = '1f2a1c6fb19682fc4b971cc401a60cc96d6beb260f35b8c2c82c3304e65efecf'
AND (
token = '7gH2ugqYfoF22vQ8xbkov5IjOF8F67Zcy3QXbLes6sY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)