UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0ZP0jSv+gwSv9LLps72ml/LGljqWla2J0QZvncgE6c='
WHERE
key_id = 'd8d6372f93060d3c801af3176c8793d5be703959a939df66cb4a21c2cebce27c'
AND (
token = 'u0ZP0jSv+gwSv9LLps72ml/LGljqWla2J0QZvncgE6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)