UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zbwAXNqe+x58YEJZw6qobkbnyjoJe3jCO/vDwKNWzrk='
WHERE
key_id = 'e638435b43298841b9826e44ae14e3e6e87d3b93da49dfe53f1118d94ee82220'
AND (
token = 'zbwAXNqe+x58YEJZw6qobkbnyjoJe3jCO/vDwKNWzrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)