UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/otFvzlKOzTVBxNnfTjvNOkHArNcAYLDbwWjQ7QkYBc='
WHERE
key_id = 'e813400aa2512abd6a5ebdf69e6ec9ca3c49fa33a36cd3da9e93bf146daf221c'
AND (
token = '/otFvzlKOzTVBxNnfTjvNOkHArNcAYLDbwWjQ7QkYBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)