UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sQjbKc8uraj6smFg5QeYoSPI7hbQte28BTnre4sEOk='
WHERE
key_id = '7f1144ffd73a2bff2774350913c823a8ec5f5e712cf345003d32cde42d8d1412'
AND (
token = '9sQjbKc8uraj6smFg5QeYoSPI7hbQte28BTnre4sEOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)