UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9umvLcWzRt/jfcJgKOE3fi0YWHxU6qVC1ZoW5QJARls='
WHERE
key_id = '97a4a205d78557b385cb2d77f3b56d971e3335d6054ea5a7ce42adf4619ea4e4'
AND (
token = '9umvLcWzRt/jfcJgKOE3fi0YWHxU6qVC1ZoW5QJARls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)