UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8aIWDpMhcDAIrZcrUIpmaBB19S/OGdJG7bik7Ts21k='
WHERE
key_id = '0509dfadfcb7291e78641642336b8f120975703abdbb4e73b0374e0b94d65229'
AND (
token = 'W8aIWDpMhcDAIrZcrUIpmaBB19S/OGdJG7bik7Ts21k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)