UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k6Vyn7rQIrKD0vTRX2qhtQE2Q9i+g4W0VOzFAz2fEUc='
WHERE
key_id = '54a9468cd5572921518ceb01c048926771525fc8ac9f93ef33d4c4edb3ddaa2e'
AND (
token = 'k6Vyn7rQIrKD0vTRX2qhtQE2Q9i+g4W0VOzFAz2fEUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)