UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8FezjRocjDWnsa9hKSv01gI2bicI+/sEpLXagNYSf4='
WHERE
key_id = 'c84ab0ce5dd8611ea77d511251766d36bfabc81b22298ed3d57c9d7963492d1d'
AND (
token = 'w8FezjRocjDWnsa9hKSv01gI2bicI+/sEpLXagNYSf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)