UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vdP9OEIgHXZRuaWvw6KylOVUDsBWPM8wTd2nEaJXgr0='
WHERE
key_id = '9403df31c7530ba2fb5347cc3ced2595bccc8feaf85c98191cc4b3e74ace0a3f'
AND (
token = 'vdP9OEIgHXZRuaWvw6KylOVUDsBWPM8wTd2nEaJXgr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)