UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK2kyL2+YgiZR/crtjgB8rH6J+6wvrF4WypL289egkE='
WHERE
key_id = '8b9220a48262031764f58d7f135f147f4dfc1333cab19ad59583554552a349dc'
AND (
token = 'zK2kyL2+YgiZR/crtjgB8rH6J+6wvrF4WypL289egkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)