UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUO65aZ09HXVyVjvZaA63YTv8pVGcPDlD4BujYMB9b4='
WHERE
key_id = 'bc2153d9e992ab7fb312b9f46aa52b8ad54f7b2f28f7108d244495ad7f06abe3'
AND (
token = 'ZUO65aZ09HXVyVjvZaA63YTv8pVGcPDlD4BujYMB9b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)