UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lHw7EXKeS6kd8Az2IXRrSHREnp+0awY45f6rRWYsWZc='
WHERE
key_id = '6cd04509ba81a4b31684a15c3e05e42a22215b944f1ff3e4b13622d54732cff6'
AND (
token = 'lHw7EXKeS6kd8Az2IXRrSHREnp+0awY45f6rRWYsWZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)