UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7wxWJLe6qYQrovD2AKFMUU3BdRqr030OgkfC7FckiY8='
WHERE
key_id = 'efeec6405e45d6b0967b0c67f68dc4de7d8aa3ab0a3c7847b2298b8fcfc03b06'
AND (
token = '7wxWJLe6qYQrovD2AKFMUU3BdRqr030OgkfC7FckiY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)