UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2jRzN3PUU8KCJAD/zJkC0xG780m01GEz6qNm76aUVFM='
WHERE
key_id = 'f21e432eadfe1a5c9f3207f19deb12e61511a9ec08c104b6fff3d44b82aeba97'
AND (
token = '2jRzN3PUU8KCJAD/zJkC0xG780m01GEz6qNm76aUVFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)