UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPeVKgZY9JqZXOKsK7dLF1GX6FbdIyPjqp5TZAbgaO0='
WHERE
key_id = '86fa7b9a4a5834110d9a69f57f7530aa4d5e69462623ee55a9306364caec407d'
AND (
token = 'lPeVKgZY9JqZXOKsK7dLF1GX6FbdIyPjqp5TZAbgaO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)