UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hChP8veZbDUkbgvs74RrT84jK4hMQ58+If7yBpIxTw0='
WHERE
key_id = '6b4da2c9adcfc4e4f7bda08a77db24d605f681ef726768bbf82d3e98fa7e639a'
AND (
token = 'hChP8veZbDUkbgvs74RrT84jK4hMQ58+If7yBpIxTw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)