UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEBid1K0VTLR7zApYJsSOAX0f65Mlci42DTA1yzzKC4='
WHERE
key_id = '498c1786ceec0d04955ea95df479b1b38029a200de7d6decfa1f8890ade0b2ca'
AND (
token = 'oEBid1K0VTLR7zApYJsSOAX0f65Mlci42DTA1yzzKC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)