UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiTzEYBLJK2OATMJcvZRZCjJqLOVNr3/otwwkRT+aEc='
WHERE
key_id = '110b06abb8a481e50f7c6c70934785bf86f0667e529e59356bf4f7179584b1cd'
AND (
token = 'XiTzEYBLJK2OATMJcvZRZCjJqLOVNr3/otwwkRT+aEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)