UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20SLcJ6IlDEACoy5iFxgPWOOVqI87dPaWY6yigp6E0o='
WHERE
key_id = 'b7ff493fc06361a82c40241d9ec3139998844426a48cb0588ce506ffe747fb42'
AND (
token = '20SLcJ6IlDEACoy5iFxgPWOOVqI87dPaWY6yigp6E0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)