UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x67OiuU+mKbshOOOGy/lGr5e54wj6JjLpJi7Z2ar8b0='
WHERE
key_id = '41f77ed27097420e332e9b18cee7236318d809d7f13828c697b3aa9863e717a9'
AND (
token = 'x67OiuU+mKbshOOOGy/lGr5e54wj6JjLpJi7Z2ar8b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)