UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bV1qM9SgEOicW1pUG7X5xWbxYHg33CMfz8zIrOB6ppg='
WHERE
key_id = 'b4846c20dacb8e0eed8acd19f26431bb7a2481fd914f380c6bc1f084b1547397'
AND (
token = 'bV1qM9SgEOicW1pUG7X5xWbxYHg33CMfz8zIrOB6ppg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)