UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mkM9EDFjCAxpF+DbLGKhYFMzhoFlZuaqUSqo6Ff7ZnA='
WHERE
key_id = '9367f4b63c2f3c4d4098379f3a97ab7918e852d4386f0d6de3cbe6973cb94dc4'
AND (
token = 'mkM9EDFjCAxpF+DbLGKhYFMzhoFlZuaqUSqo6Ff7ZnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)