UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWPMjFpDNs3b2kh5bfm8lGhQnLutClZirqPuH01ac1s='
WHERE
key_id = '3196228f1a77171c4ec4cc1fdaf8e441081d36ec82122c713ebdacb905f6845f'
AND (
token = 'pWPMjFpDNs3b2kh5bfm8lGhQnLutClZirqPuH01ac1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)