UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZeobbQRQtVoXtj4Nv6kOvl88pItI9TUM7zEIx/J6as='
WHERE
key_id = 'ccb271b9349ff8712812a8e3cdb27698d720b36b86dfd3b4166872e99d3b3ee2'
AND (
token = 'kZeobbQRQtVoXtj4Nv6kOvl88pItI9TUM7zEIx/J6as='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)