UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bN54yuVQxStbkfyk4qbFQPfQnOxzXrWSX+Grb/ARJMg='
WHERE
key_id = '9d9946f7f61cad43e001a9d13a038d1ff0f4f003b150cd0606a2e376cd3fabfe'
AND (
token = 'bN54yuVQxStbkfyk4qbFQPfQnOxzXrWSX+Grb/ARJMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)