UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QigyQRJrsnHsvq/CX+/au1dCmg27hHlYNgklRd+WT7w='
WHERE
key_id = 'b50ad148086b7965fda0e9101b7ad13f68c37bf39ae920b02fb828077cc4987e'
AND (
token = 'QigyQRJrsnHsvq/CX+/au1dCmg27hHlYNgklRd+WT7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)