UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPkh9Ky6ERXgGXpETZgylBFcZEFqHVVU6ajmdTxkeZg='
WHERE
key_id = '5727e38d4e6d403a43771f7d2009b8b113db3525005cc0214483b812a9ce6ab3'
AND (
token = 'ZPkh9Ky6ERXgGXpETZgylBFcZEFqHVVU6ajmdTxkeZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)