UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcDoddVaG5LotQoAPGiGGg/0oiF1lrTs/Nfo9mEdi5I='
WHERE
key_id = '45e47f46d195a836743a8335291277c9f996ec80cbb816c3f1e139ab9f7e43af'
AND (
token = 'XcDoddVaG5LotQoAPGiGGg/0oiF1lrTs/Nfo9mEdi5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)