UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20CEoH8i5C1jg7VSBbi59eXFji+AePmknPc6iwxj4yU='
WHERE
key_id = '2b1763250ef9c8047679033420fc464a5513d7b0d9f805d774789429755da86a'
AND (
token = '20CEoH8i5C1jg7VSBbi59eXFji+AePmknPc6iwxj4yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)