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